IS

Liu, Baw-Jhiune

Topic Weight Topic Terms
0.216 decision support systems making design models group makers integrated article delivery representation portfolio include selection
0.166 set approach algorithm optimal used develop results use simulation experiments algorithms demonstrate proposed optimization present
0.152 database language query databases natural data queries relational processing paper using request views access use
0.150 programming program programmers pair programs pairs software development problem time language application productivity best nominal

Focal Researcher     Coauthors of Focal Researcher (1st degree)     Coauthors of Coauthors (2nd degree)

Note: click on a node to go to a researcher's profile page. Drag a node to reallocate. Number on the edge is the number of co-authorships.

Chen, Gwo-Dong 1 Horng, Jorng-Tzong 1
decision support systems 1 genetic algorithms 1 integer programming 1 model management systems 1
relational database 1 SQL. 1

Articles (1)

Extending SQL with Graph Matching and Set Covering for Decision Support Applications. (Journal of Management Information Systems, 1994)
Authors: Abstract:
    Graph matching, set covering, and partitioning problems are both theoretically and practically important in decision support systems. Numerous decision support applications have been modeled as graph matching, set covering, and partitioning problems. These include applications in the areas of task assignment, marriage problem, airline crew scheduling, truck deliveries or vehicle routing, political redistricting, and the like. Currently, these applications are supported through programs written in external (to the database system) programming languages that use only the data in the database system. Thus, decision makers or application programmers require extra effort to get required decision support information. As opposed to database systems, the purpose of a model management system (MMS) is to make a wide variety of models available to decision makers so they can apply these models without having to become involved in technical and/or procedural aspects of implementation. The goal of this research is to integrate database systems and model systems for zero-one integer programming problems especially concerning graph matching, set covering, and partitioning problems. Users utilize a single integrated language for both problem formulation and model execution. In order to achieve this goal, we extend relational operators and the query language SQL. The relational operators are extended with six operators, namely, match, maxmatch, cover, mincover, partition, and minpartition. Some of these operators may take a very long time to find an optimal solution. In this article, we adopted genetic algorithms to find a near-optimal solution of this kind of operators. We found they performed well both on the computational effort and on the quality of the solutions through a variety of test problems. These algorithms are bounded by a polynomial time. Therefore, they enable a DBMS to respond to queries involving proposed operators in a restricted amount of time.